SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554936 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554936 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914274,433248,1023751,1023668,642701,449260,305681,147235,1032360,810012,722378,964159,387708,487890,952388,502319,577216,136270,916887,451871,439508,804571,466132,760161,117654,924672,520690,404929,13184,164588,772748,834531,498726,496709,185097,370030,749682,580501,370131,788,594407,677012,203658,280095,329891,541309,1031145,207385,333295,987561,978084,965404,876315,933836,645447,686084,206529,706384,760274,724290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]