SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805473 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805473 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565730,511395,193771,388321,1032105,748885,201507,295908,889942,338721,613890,836994,795997,319589,742574,699211,907428,263617,764152,522012,384313,97774,127490,167448,549184,538216,572932,388573,468494,417938,1031188,201343,109676,262041,330753,701888,453969,40689,801741,40099,753403,515916,636251,763643,774961,300369,68393,897875,262428,997586,84286,155816,1999,226269,724142,888129,792815,432722,286272,796440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]