SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483812 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483812 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139277,753797,408753,500779,679144,914403,257271,783134,56558,432892,604391,739226,602117,335208,891288,747380,545345,591901,873757,682522,877726,356985,621841,926944,652160,985033,674514,551552,108541,781539,722526,87837,499276,115205,450783,201470,643568,1014353,423094,839518,973063,539870,862471,395116,138320,745893,343316,408058,961996,843662,48348,536733,955033,540104,560549,198108,544922,647688,9317,822909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]