SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522791 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522791 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254746,798648,147170,430007,301886,540898,854705,673565,658395,534504,148599,997086,100321,967785,946334,488763,761495,331354,753654,1010704,840659,432261,651955,861770,179943,988208,72747,981823,849168,724656,8859,741745,482444,432755,685452,12449,763178,249995,989780,785517,402679,467419,344583,219265,673257,46364,789590,974400,855661,432745,872085,664731,892223,1045387,252578,470276,674492,182552,537234,105611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]