SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534482 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534482 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852947,520441,941623,237796,188949,125745,687525,196896,985525,253575,452090,361981,682623,410762,489848,872209,768229,841435,653607,886989,968770,265890,881528,452888,937855,830205,723016,698057,982505,647125,538107,700459,942524,673533,6040,789424,858443,805112,59872,527048,897156,386205,612659,559155,767018,305444,463001,643911,790463,938623,303583,53767,465385,36594,408615,976640,618895,53451,48809,775364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]