SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402749 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402749 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25578,775131,560486,422015,707424,314638,878083,130539,271688,168530,696582,441105,53136,891941,175665,274935,354323,78868,966613,181070,754480,679032,327489,911837,23475,219771,139734,860258,310485,259456,746892,324044,686888,800119,196308,519145,952464,234171,80690,410257,875870,164958,17071,15470,962153,262486,233770,772201,507247,1016749,668745,870663,370000,992495,312188,497407,342470,244609,548903,351719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001387s ]