SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027918 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027918 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189835,500705,347251,740365,374876,120478,382456,19880,382224,226613,823577,386256,212804,241733,292326,427390,284289,739235,812460,880650,161081,443927,658722,611301,501839,330923,1015417,169291,726691,996814,378753,181409,1039728,130231,557928,701730,375874,694188,908395,1010110,537408,45516,53197,698162,706821,400006,739511,943618,360651,873429,931662,115481,853166,9916,153350,480440,147898,754988,959312,506976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000960s ]