SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711223 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711223 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375354,427317,164672,394711,141291,1008665,487688,105437,104411,951571,313312,717419,582929,973398,902387,831218,1013355,818871,320019,163226,550981,659175,38038,351867,352846,169288,393342,122272,248376,676858,740660,215712,976521,387315,982308,608438,519977,572627,382907,871659,155994,54659,130481,788600,1007432,683723,848249,854785,52559,927599,227082,515029,766647,345080,1030028,142855,205170,268181,21196,854821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]