SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538930 LIMIT 1 [ RunTime:0.001337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538930 [ RunTime:0.005149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744916,98637,603349,461710,111751,593924,1043843,493039,585412,784268,24284,616536,598889,281516,874014,361830,782368,255889,592771,362747,984147,703818,276261,885798,271927,724087,716377,840362,709144,795460,802975,220520,104785,919551,957998,666636,714972,771522,138949,1009134,924845,1014564,1036621,151467,274541,1001920,226034,918996,562009,284638,678511,551529,940220,228146,560280,786891,140646,334195,133798,271076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000998s ]