SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105009 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105009 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332625,852849,621999,741385,988965,936625,225258,955885,699916,417163,784533,533437,160913,818946,501906,77067,144340,1046864,547889,448870,849144,970713,861470,159954,67189,732870,18975,1031247,167417,584885,391248,788372,312168,773886,911490,562063,957018,1018429,1025927,621781,483059,658804,611464,843872,425028,295945,483797,646220,990830,347457,9172,156878,291223,40317,200584,625000,1024911,260612,303071,628148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]