SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534036 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534036 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259840,29364,93145,120014,1047733,192611,332715,779,352189,59893,60295,421843,866351,676212,424991,928057,476051,123749,754036,41503,482765,906514,829170,176041,453569,946581,711950,329953,789310,806164,691739,706061,474966,679309,107060,349607,870667,878589,707587,120666,968020,275223,778828,694730,998055,954939,1411,403171,771305,1046044,362924,78794,486709,912567,717443,485166,882386,43248,185735,585982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001312s ]