SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329812 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329812 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202601,841911,80304,16528,139990,135931,131594,297361,56594,620582,754559,624571,102597,622711,236802,781118,399349,185235,273543,974542,861988,885201,368752,441424,299621,980766,305965,230020,6619,898535,408844,846487,1002760,362110,134062,206924,258014,611173,736647,610142,674671,744223,788877,473044,961401,673548,715552,302248,224699,1002038,651419,80057,283968,492472,485613,480138,201327,690490,309212,786518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]