SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401853 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401853 [ RunTime:0.004659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674610,1034857,667825,604029,120395,193313,680679,95074,160942,399040,719802,209401,819345,170380,141505,252372,729802,774284,847148,118316,867776,483219,216772,240680,694385,132307,29966,958055,93371,398712,238379,446560,139814,545995,673832,90327,1041857,783099,11781,580680,567619,954338,199032,1016336,69720,40133,950178,127808,139834,601306,899978,221705,967425,821570,973419,700672,46070,649454,712120,491944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]