SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037263 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037263 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93776,496371,199728,327971,1031952,420450,361227,318617,557308,209923,893960,602723,417704,298661,243920,853052,8639,1010514,848393,1031903,566616,415840,888408,1283,579056,399189,261756,618150,167033,365293,589627,775208,778509,439629,598327,900681,997673,344917,128304,846854,452910,803975,622859,860021,470894,757967,851566,324890,792415,174757,557495,583971,507577,824182,951781,945602,391266,478058,1006850,155230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]