SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046023 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046023 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540347,1042103,857138,850888,26114,137491,29379,962648,210570,160696,1012169,374756,499805,448165,70859,8714,666941,607327,498858,61600,139011,701800,785133,339769,922976,468523,804100,380571,371494,832213,122078,125071,726704,307293,15631,135783,64535,590555,151094,989419,817224,699222,509016,979134,779514,33504,302345,689033,2909,418143,117815,802800,933620,284455,575088,86262,993404,85780,258688,436747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001240s ]