SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261322 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261322 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478852,370699,574968,200333,376382,818345,593735,264991,722926,197285,100938,428666,38431,224693,163894,144056,855445,342114,432724,100508,1048093,482359,528812,1042197,636364,932532,50010,894982,188992,127914,371435,636847,92024,137372,94543,912034,1021151,676319,935381,869899,448642,216145,989347,564287,345991,205449,103080,231714,337861,589025,1030180,275328,1035324,212531,152641,64779,80194,555536,289292,867343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001171s ]