SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348415 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348415 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540412,368221,449509,892608,999735,24504,583321,196142,429761,78897,883072,945284,613349,133331,859890,97974,604511,657472,424544,778693,833229,294103,1019335,452608,1044868,534532,697420,272826,127348,356724,527859,27256,924722,1045140,253863,605695,402700,332983,3569,824212,975476,518374,941001,583869,134137,380973,74482,27172,914736,370845,580027,1029934,445227,902827,718869,172091,924797,899431,493629,469931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002394s ]