SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200359 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200359 [ RunTime:0.005805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18694,621745,57007,1030699,491670,427394,5833,821583,967058,767941,190608,1034053,295230,443798,386953,422122,543922,347675,207869,524888,805368,527301,399791,836117,1006905,931633,808757,344042,282694,668657,809082,71645,909684,928651,372404,835696,687144,127483,70585,385670,573550,531005,781624,57184,632460,478451,435901,376032,961361,914261,377322,10209,561044,857342,18956,38077,393105,297615,895835,761807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]