SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005414 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005414 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44971,532707,477803,742626,318049,427425,722175,526580,1878,472320,1035321,115813,97317,955993,239749,884128,577284,276792,615500,1041365,420420,424783,423111,988710,196061,250365,703676,968248,429626,547024,414747,742470,340780,410676,847828,19431,471958,159874,259346,475649,594457,318064,332355,373108,296928,116202,219257,655825,820464,465877,111965,975671,286718,110710,422949,1005788,812471,402450,121200,641072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]