SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012178 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012178 [ RunTime:0.003011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655519,288611,444945,735547,494506,271411,959906,471033,804990,67892,740312,748230,454303,299901,871631,437717,114672,1047848,678553,817929,457214,249411,995742,460105,188091,581744,559917,908922,15336,903383,668103,747004,1048768,554061,808331,135766,999000,113349,402419,63897,268326,718856,150036,1039450,284045,925770,506077,210273,942573,850723,570036,635854,651766,960045,981220,491870,1035007,76711,776568,366738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]