SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486903 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486903 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206173,328863,987641,570828,950154,206622,855380,895602,472052,684896,44649,521744,91144,691441,449559,804927,737865,340456,618207,785670,335716,10665,241437,548462,368927,285139,784430,257107,111961,453661,205205,791830,56891,744545,782320,126653,95402,660804,553441,1046602,399626,775601,814986,639767,988060,698031,48167,1029580,737600,55604,164264,411851,863176,353841,626765,451790,745578,112288,228109,794840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]