SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001336 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001336 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194065,593956,450217,819102,302237,533445,661784,1012833,10740,174740,397936,919125,240171,375262,922833,650564,306523,1010330,780065,369577,313120,234356,423856,469518,1042954,388560,818443,603851,581993,608643,887224,745466,454667,12972,818307,892321,752944,850585,1032047,688811,370232,174932,511037,741726,256611,94097,61264,178556,957751,24976,485431,847964,50051,303863,437094,215477,469915,511777,343495,382144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]