SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018300 LIMIT 1 [ RunTime:0.001064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018300 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753326,1044742,610707,1021523,14816,1046986,108714,39149,519948,848281,569164,587062,208711,874834,840693,432628,584200,254770,810454,1041680,373917,907947,373511,887914,719123,422360,317513,718351,1030492,15409,830945,853247,800315,687388,928146,805522,723924,136729,169230,724067,524905,1026950,793544,1044277,851626,677425,536038,463883,39154,625793,521081,670772,243666,198500,935323,200162,171502,979050,283861,550401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]