SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263671 LIMIT 1 [ RunTime:0.001705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263671 [ RunTime:0.003696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762057,911540,395857,367864,760986,1029583,147307,875637,226494,165385,452118,863977,1025035,988103,162070,228134,1032510,330125,1020966,807030,57089,108107,685370,357337,485079,566301,25678,109669,521804,676211,121689,374086,2148,421674,669604,863340,1001295,7159,492738,1035632,700498,716088,685006,684585,455796,771449,1020840,1004932,465538,373133,923174,381360,830628,444286,824526,149323,865797,252283,498264,358827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]