SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410673 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410673 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645139,37125,802704,89909,484239,250323,1037562,1017335,622722,916562,815422,603725,323799,48423,590264,572742,501426,316863,63703,352896,17723,438316,821502,193131,39315,353487,398479,223274,652587,860285,634326,439099,721180,567565,318269,867854,647773,554930,970861,511799,1005987,121959,462527,407852,749403,591088,415599,472343,639888,446438,803027,442754,659383,559531,593239,252932,787790,580335,452738,534000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]