SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328812 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328812 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714000,16781,598474,556711,875746,331040,333481,428913,731332,563500,549364,411771,433228,987567,220223,280974,781584,818578,1043165,586750,284588,991315,637860,703999,815298,123966,536975,1007724,353803,65649,487689,635951,1032039,738631,203939,209974,704371,375315,909425,450730,727887,240216,402202,462771,160386,288228,770321,500604,979597,791928,456091,541715,179095,848343,1010679,257586,140112,406534,50005,346130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]