SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861996 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861996 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201050,491964,172886,806368,145222,482005,819925,903831,463937,372418,80113,690351,1023160,412950,514284,641435,117928,310726,52023,124091,1013570,423911,463424,426628,2819,126691,803997,769729,21013,639964,624568,759547,801832,397820,852605,370684,642331,80153,571936,98966,717516,153414,711764,932645,299178,971745,869683,654456,954931,951320,115663,214387,19064,540888,1012824,403634,802082,33733,741477,388847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]