SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804138 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804138 [ RunTime:0.005994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880987,908313,537580,969653,244982,606554,359096,226011,260817,974384,872410,511072,202815,1010112,535913,796263,618900,290685,186132,633475,478166,909115,424999,47962,816550,205904,701567,1034753,511758,677102,936798,589782,872299,1017844,33456,423442,963898,104305,598462,509984,632173,577353,52157,1027330,752524,978179,465162,82527,829368,327160,510922,755422,588910,519624,305451,37382,945393,914338,892212,1019170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]