SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555831 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555831 [ RunTime:0.006285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376224,126362,831392,371326,847400,712868,423587,859539,3634,734574,220698,852291,257170,428762,46825,255643,557464,104044,1010018,712550,552571,224315,453383,717380,922507,37618,537882,659095,84427,521178,425724,166660,572151,529661,516584,519298,188040,278134,441746,954254,132971,1017927,750973,1026007,337003,547328,985037,859036,674177,100608,396600,430135,387914,777566,852753,528637,766734,485972,778950,88006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]