SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505769 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505769 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804123,366763,740294,13510,259609,1013759,771616,35910,285595,47271,741696,743088,1014671,980511,732945,207048,865544,449671,133278,839269,540835,373725,781129,963872,211550,36328,533124,544807,865874,172305,174209,290480,889004,263325,992250,56207,453060,54644,422942,474826,396895,516157,616860,367731,322369,342964,167508,284856,863828,815302,761181,542934,667618,971119,769978,354758,493590,905641,313001,1038388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505769 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505769 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]