SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031046 LIMIT 1 [ RunTime:0.001081s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031046 [ RunTime:0.002817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57841,3819,982521,435927,857369,473292,585955,422593,1040270,142013,701829,796990,888351,1031367,549277,364429,220558,260173,631013,850509,1025535,939501,326344,731530,551971,493465,750946,991286,838904,261046,1012040,349996,24985,1013290,586635,444606,577009,72095,868142,311054,604142,599044,764473,192036,214631,212775,842954,376173,704710,430770,1010246,642237,625195,1003664,553940,1044772,606328,935769,346184,1003386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]