SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018100 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018100 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932997,724012,251340,993607,29301,183261,917938,971181,919037,544266,741890,488094,728785,581475,576081,162029,791445,566473,944588,506926,205651,960241,481863,211698,856915,301419,727020,1003569,220259,395535,9271,126996,216496,326033,982622,55016,585047,867191,560673,525259,67227,551212,539265,638566,68915,46905,888477,177062,490738,762653,353871,671864,511578,645682,613445,167847,203113,33742,817338,724960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]