SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011078 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011078 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71857,662097,41621,717510,138827,313545,300272,568474,127837,145792,557842,270113,790879,465713,593052,575724,956008,10863,282272,771492,821459,331808,1002384,904825,1015648,876772,508084,52609,269463,961448,644617,164315,454650,861983,5120,523377,396063,745451,607413,885118,806740,754106,545160,229988,791073,215902,80299,656708,759740,348754,104715,453357,14749,67249,868402,163770,447730,216382,909508,747813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]