SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424628 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424628 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693923,211966,146419,243011,704023,193413,434686,888704,82921,191414,489053,308121,783101,620518,978614,293197,676356,355226,867999,386290,786245,120490,426306,180366,775018,225784,387920,831755,517964,711900,859683,259331,105082,73783,543692,189986,426879,902593,409990,704432,339296,223316,928179,86339,499457,47121,881929,689272,58318,258502,629501,173382,110393,64625,980607,844811,903181,324198,226088,588507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]