SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317568 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317568 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648854,212160,802943,224266,82927,545136,700338,605602,422268,923712,417935,220472,285174,97099,731715,724223,226329,639903,139414,846841,118079,237587,371894,223474,835022,64433,675763,28601,831602,202977,609603,107512,484465,941052,944323,66086,365482,440670,58939,74791,3218,652356,107579,582602,549553,701572,1020950,590939,518992,741152,454436,555520,1037237,381349,778934,239079,875862,389612,959040,765285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]