SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010440 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010440 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263468,594980,191800,639543,779002,540714,428995,41702,761945,397249,551789,523606,202548,947678,480395,270032,319660,466696,712158,397904,630913,140542,818014,604059,138575,324990,117555,929865,36358,916808,789556,577413,412499,957662,1001399,497502,965202,876549,372307,556986,160699,281674,907916,926635,573450,198094,651137,668674,899196,989441,880504,492960,225869,410267,821329,34844,134122,134701,84681,445550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]