SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782880 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782880 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193779,517549,643848,503640,1563,760385,602694,690688,457407,493373,952758,409348,737092,351417,961140,398429,137094,836413,740937,136386,634411,487456,801446,870603,630847,395993,322054,748146,704710,825134,869895,786821,184122,599802,541687,726737,474627,450852,1018426,695990,1040813,530313,544795,426410,571256,414546,144113,271829,1034541,826059,665748,39375,345950,977263,413389,851730,734234,163855,832977,540287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]