SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47167 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47167 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001696,356521,68888,772186,1024228,495894,966132,61174,318569,610191,869960,439464,683465,1047557,814953,983528,1013645,831994,186524,475682,447971,628199,418985,706185,504870,1046629,320004,1040047,78549,44872,128238,382492,945549,698873,353738,10476,875105,476644,969237,952016,988529,782711,1013211,619020,783556,767621,792017,901118,172224,209084,67392,216244,315844,414150,977468,714697,376819,170990,216280,416236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]