SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200888 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200888 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511037,100134,94349,914458,631692,540865,225418,719711,356054,400832,509681,659527,875757,963150,228253,927847,194803,631572,718401,685685,119178,16094,281353,730076,972609,606855,447508,455836,524677,915106,883297,293362,302968,317035,751746,40488,428160,1010308,890796,240917,768947,466513,869632,670324,692929,625496,608077,300599,301819,923666,619574,80636,66047,916914,718965,169085,990515,524436,1009992,316957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]