SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004210 LIMIT 1 [ RunTime:0.000917s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004210 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890291,368875,213745,643143,48526,251397,623559,18159,975024,955260,251000,379047,281267,144775,829805,1041654,266498,206948,425697,238864,343178,969320,437742,1022332,419197,53523,49716,850250,104036,610058,52083,485649,936242,338172,406541,980068,51137,800010,304763,887681,482601,470575,215964,360038,471467,576654,775695,1020634,184713,115664,52345,1027770,560378,771291,130107,214674,564590,178461,989193,982776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]