SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140991 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140991 [ RunTime:0.002779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636075,28580,182714,1014113,200350,753060,1039256,518579,356801,628983,507257,32184,114742,655821,104427,966703,759456,1018323,1020158,280014,491162,433106,168573,628225,425581,205961,894018,48729,798149,441039,272786,841642,634242,251932,66465,575969,514377,564817,637159,98763,654179,546248,207939,113757,802718,699334,212509,900562,964143,215741,505424,346915,364976,687418,358224,704478,1023318,797550,334604,189703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000346s ]