SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040218 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040218 [ RunTime:0.003036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269829,916881,969301,879397,489541,729213,682361,435753,783990,316076,232327,474245,776206,229615,754221,468393,299754,179256,290017,296865,736135,109358,477183,896645,64526,461318,297278,459351,613990,470984,925743,464838,401600,831694,819293,583787,297469,92474,368019,223798,160774,54677,195260,627928,321537,372203,660777,268885,740115,711283,411865,563301,833618,57783,188570,585503,487274,332182,980235,718379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]