SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330415 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330415 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526096,481792,95755,768671,324658,803376,843803,567953,704578,331515,688451,360772,347069,448070,212008,522549,620913,186930,3643,767176,873694,357110,644137,550929,515642,140062,260745,204507,747192,163866,776567,586183,82523,645142,615998,189919,124522,579818,625301,249049,797438,530745,918559,61253,204737,1014593,996064,796333,943704,43469,928620,1037653,743141,51213,1020542,831185,775675,670053,563259,710229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]