SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435974 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435974 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543341,479175,417816,446097,486614,120180,867309,850296,365609,598539,739968,248931,137053,537945,562191,173098,243945,377112,252430,259318,222351,571256,212967,499306,967326,103531,378824,38478,454318,660837,129745,135128,352670,258161,1009552,447761,598826,940644,644102,914040,998779,821622,949273,470661,427091,764867,894420,519247,104531,164879,876187,441065,957173,194526,918854,168165,898055,952407,135115,970071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]