SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503117 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503117 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268850,878731,965475,408308,453338,237296,772834,142959,358018,988778,716092,623657,818518,115845,839338,33013,261371,538808,414485,164685,1047698,511351,819026,987447,757032,286526,566663,560820,626633,149337,933002,239315,241269,901259,8376,316931,1010828,444668,746726,598098,760427,68405,916166,140904,175249,362522,674351,327828,665424,662388,596949,1045098,481229,1039299,220563,113783,600182,573776,426896,541748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000878s ]