SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410450 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410450 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123309,238848,35891,48070,955832,787714,804529,629107,340792,802759,944029,968932,513134,739717,380487,271341,213728,44160,328222,461574,840858,447486,669145,430060,357612,269323,644849,216026,43768,1020991,27367,854511,154393,97161,896611,675041,158127,622499,154404,945105,515388,225466,785764,524090,37688,533153,534303,1023857,753505,551281,785398,636192,474413,975424,957090,613395,350857,756872,282387,763231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]