SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475218 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475218 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360742,416381,281536,509700,863329,651844,888966,887974,522057,455943,1029257,434913,474707,988804,623503,516628,31157,92499,485362,699203,691508,565008,296820,754416,826022,538570,582125,567812,431659,118335,451559,425558,595209,214313,353148,1043043,680822,338449,863592,89587,289980,451378,893400,126106,351420,453121,391233,39228,694212,989432,860908,729068,51970,503580,888210,19455,471620,604371,937773,611120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]