SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291895 LIMIT 1 [ RunTime:0.000966s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291895 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410054,406241,46836,275233,510433,73373,25147,74022,671727,507657,12152,419530,18285,607461,608698,345874,127430,306283,570905,20588,969970,188357,1043642,379602,1039138,598907,188778,93417,78553,463512,697004,948085,37284,830410,264064,169676,788126,126689,1045301,67196,946676,773098,977713,275792,551721,122629,888293,404268,25390,1003390,703369,502312,1001105,991820,909241,963201,465610,593454,493906,328224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]