SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568943 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568943 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88435,1046694,1016321,245121,737793,646731,43450,105148,826666,590550,808209,986216,825585,109961,501499,135052,126923,471964,762594,869446,344881,549410,576713,271222,241634,317299,565737,393754,792917,792343,413397,438826,790543,701834,640263,853166,460833,258956,1023286,751535,806556,899705,207594,893758,53138,576802,954915,352124,341337,299580,852741,256161,1025522,524185,957254,791248,313483,889102,933854,621000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]