SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517543 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517543 [ RunTime:0.007114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148022,432441,540276,699271,323721,589028,816396,957221,376898,192150,730833,311060,174084,601469,862773,323045,1017630,823415,1000202,225486,553656,682966,733867,367989,332108,293525,117048,862932,476865,323943,221077,169514,929797,851561,703755,213287,1031917,275095,833147,745120,811705,869134,701130,792525,852325,488016,633382,822782,872412,704591,659734,296613,210314,632309,518291,317292,44419,798423,237606,551296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003604s ]