SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590243 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590243 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666778,190447,773982,582763,1039079,904890,745722,565901,862788,847810,164312,1041961,96329,778974,211916,710637,277363,49163,501563,788091,580845,420077,294196,642220,835415,773236,708065,840208,355998,547038,761892,336297,972270,24516,396268,918546,421672,706016,77063,970030,487679,147220,323228,43806,971500,531518,1035545,552612,126356,128940,518900,938441,248129,37000,662485,670589,909986,109180,32869,953693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]