SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028374 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028374 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022266,839241,394923,729546,186378,258579,851521,262831,346429,930683,37284,124636,25209,648796,574780,553217,594817,882801,79875,823032,686999,906228,830020,190580,731871,172113,246846,975371,226999,627417,431425,295493,453053,938324,5019,519629,303333,847704,1027978,500531,222915,155025,648294,555891,132167,215812,995366,940753,147729,163746,127543,228549,677825,813207,635553,482959,723760,673506,617875,339011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000934s ]