SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142311 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142311 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192709,953694,179692,156226,549570,1008121,981864,1020933,743387,663801,443326,571750,984641,1014519,825817,150996,435491,735223,774080,348118,553317,116099,145213,47138,185878,916772,48318,601552,706456,483183,298366,663460,714421,461594,3049,556308,66119,92109,312828,287046,836481,431923,575463,713190,657161,889172,885199,310390,342096,1027904,512065,300547,653604,727959,191143,301942,841314,651536,270323,154531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]