SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249657 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249657 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54056,318959,545620,846264,295959,1035549,107562,529889,346794,251791,979639,177462,758315,746539,14338,296167,1017666,331067,858890,712844,727892,486538,255532,363283,413875,951890,700140,990717,978660,790200,445952,447160,291509,38400,946700,964633,734895,563852,476324,218807,1039644,468949,412175,418390,894268,455713,606158,140768,202774,429967,118434,987114,3899,883621,445181,185569,486964,586109,712196,516338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]