SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031392 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031392 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250999,634773,271693,320240,941782,198750,178137,360023,121582,187583,90211,825069,589431,45422,380645,278927,503610,157315,284293,377052,361812,244098,605494,495434,882640,470203,365025,87839,207921,323388,443072,958060,811016,618640,524025,140338,132167,444005,318293,6564,509539,465017,155,332021,415156,345207,361253,1047126,411985,33936,919803,655032,877566,340521,40227,632399,840980,230258,235098,907880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]