SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814528 LIMIT 1 [ RunTime:0.001969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814528 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042376,773432,356512,450346,275885,683278,904692,1040160,978064,453907,839013,942514,989331,498045,575586,887296,682486,288897,201058,828102,980441,253361,392860,528755,673365,306589,294991,523001,841147,397758,266268,346317,508668,819298,528078,789396,453512,547013,654724,275844,357033,766956,154756,266525,46240,193466,416847,271798,588935,986146,422521,720309,115046,721414,359928,408937,959928,174532,96532,353108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]