SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502638 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502638 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864226,268534,135134,1019675,625779,429601,933542,764112,950520,11225,755467,294794,59064,387237,370443,835210,716022,464118,823280,894704,990798,898385,262271,25511,477743,3658,157675,6679,764338,998656,948371,651019,1000481,483507,725331,146095,150690,426872,638676,130368,611276,899520,754104,487801,95673,7600,966745,225216,61237,402931,1015977,773309,485847,978460,989883,281731,214474,829465,648404,488625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]