SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045615 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045615 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456112,416072,73658,128422,341626,877792,555882,724711,136948,574813,415027,200934,23006,403908,907811,1027622,576465,195661,677621,465036,833314,457901,142906,760966,44291,425628,112171,340148,711349,529681,969194,858433,487096,201806,768861,48103,192768,166718,44802,231130,577419,101950,189657,551689,587027,36020,1003396,295960,148007,919495,220241,294404,720662,684880,750351,887290,26677,370039,614872,283356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]