SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 186480 LIMIT 1 [ RunTime:0.004363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 186480 [ RunTime:0.006340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194401,582518,1008007,64263,909806,199608,933622,36394,68508,901015,473977,333706,364629,973734,793876,108386,289456,405540,606446,875727,730011,642817,777891,426151,715930,203879,159309,282613,871733,98745,672660,750878,622728,336906,1023166,223380,804235,109546,534932,236569,254949,461981,974460,336624,987891,752307,947855,615755,898143,536126,659416,390365,456791,946531,110390,57,967819,815186,943292,693376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 186480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 186480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003832s ]