SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414269 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414269 [ RunTime:0.004041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485347,929931,563332,210271,69287,490673,259970,854611,849519,676534,510455,191807,960963,299599,269072,964835,474350,1018668,996491,116384,1011031,908596,250778,444999,943999,552478,399028,1041883,861055,1033368,985240,862509,432375,267913,643439,286759,622853,1029087,829985,194382,711923,26346,180007,211604,14331,994842,85136,79080,360762,216591,11622,317118,716191,475,200716,742623,402903,234977,72032,335122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]