SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425293 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425293 [ RunTime:0.003022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839947,780754,438499,213706,300814,893864,6595,358287,744799,212165,633835,836641,492540,942726,645720,749412,993184,844339,375063,698534,429535,620561,783062,59787,450457,569092,16540,765324,119300,498752,199637,757563,212749,1014135,242478,178407,580401,616364,999597,30802,11656,984407,599225,1012791,356486,11962,512047,698196,220711,610781,1046076,956840,1047178,389229,638548,312878,492888,970022,411566,167940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]