SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282323 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282323 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605053,1016520,609899,669519,455070,84639,134454,498924,452680,576588,1011438,528295,324308,517653,457906,74583,743338,864116,425065,259671,1009355,743913,1003255,508360,635437,815762,318560,587021,633173,838204,632782,610041,824298,838937,819883,565521,186198,865810,46158,975574,295277,513421,776074,804258,438075,1008302,32636,414063,615957,513961,165329,361833,104314,694790,400362,752607,641493,996458,358568,225702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]