SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334394 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334394 [ RunTime:0.003769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68274,846646,182010,799989,986488,34280,718479,515245,187503,603928,923931,606510,1019374,1002159,931074,160765,5563,394070,775288,382521,921809,800921,373988,805918,378871,379631,4987,60126,274064,214192,637364,727865,257293,75158,619253,284899,956228,115953,926448,374467,901223,865502,84641,86401,865306,482171,982047,647702,953031,18371,284383,715561,215855,459530,304083,803881,192506,962240,645783,651313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]