SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261215 LIMIT 1 [ RunTime:0.001307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261215 [ RunTime:0.003338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70808,667344,942996,318961,700267,882364,568453,466041,345357,828447,174133,839687,1020011,680454,823254,104161,1000173,141531,898665,662663,971937,295209,154004,1019878,249401,228850,395514,1028753,258592,162199,108333,488036,438170,868714,858920,816612,104668,652963,683168,647818,774721,804231,631489,154506,49515,272631,320575,1046060,971111,91961,188926,988205,663556,110272,896907,90596,693457,776330,684750,746008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003084s ]