SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415417 LIMIT 1 [ RunTime:0.006524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415417 [ RunTime:0.003523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802545,1034170,796509,617681,832767,233884,704430,1002600,1012689,376741,533722,1039384,974767,955051,845829,104430,984997,775138,605081,628856,853881,959892,749832,11020,188120,949594,66656,512711,838599,335169,1005773,219035,888239,558337,671928,879030,884740,675761,36631,847395,917262,1006918,905911,495710,874507,597018,1014545,916617,496352,586228,180206,714881,928467,618297,480708,716857,951918,599173,897753,782554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006588s ]