SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801858 LIMIT 1 [ RunTime:0.000738s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801858 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046463,118827,56536,814424,449301,83807,1025762,446651,808373,257674,135491,186640,692111,430017,359368,661761,664636,801551,447123,563038,1000453,169942,892072,304487,214557,184138,110538,459896,861574,756565,589864,619158,283042,147477,211539,423942,866304,890025,821201,766620,525997,6028,546003,265699,486550,747153,718641,583678,724778,869323,556578,83079,542645,198796,997039,100318,1036447,445577,834486,72543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]