SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023863 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023863 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304060,1034453,606092,386250,814370,379750,826538,849852,11630,951541,102058,127921,126008,512944,170067,440750,832023,733513,307041,318965,356708,871477,303407,498396,332318,512100,370962,601373,928724,769779,927263,513798,288418,878698,949828,768210,715294,507199,751213,805339,689434,893006,866729,165792,1011721,682996,936840,530698,710223,952481,253977,954487,126930,369200,135504,75861,576337,533591,237466,349846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]