SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557308 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557308 [ RunTime:0.003284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187338,151386,908566,274421,933022,197842,186080,61390,579357,522084,595552,932270,143275,698758,850409,634123,288499,448759,306690,51524,1020157,102566,64618,895579,925906,852647,172877,27718,1004914,53578,985751,319091,856420,900207,208484,642121,192355,755183,580505,249749,291706,141225,627493,411773,586649,563995,121356,668967,417416,507038,459145,472842,957624,752124,108401,1023142,866526,312229,267653,1048311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003501s ]