SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044531 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044531 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577184,828394,809764,381348,114730,718080,876165,771443,92930,691216,455239,636806,537191,480767,824725,177262,425346,960478,101029,447526,168599,148421,189974,7925,782631,212768,406646,822671,303737,708068,356263,472527,1015918,897766,147670,613707,637,533547,135482,988403,693615,363255,551869,116141,930387,412775,686842,414921,635951,443948,623055,383545,583488,673388,274405,691446,435070,967967,443145,647100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000829s ]