SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916084 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916084 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456548,1041985,1033889,730000,111982,681846,933094,610145,53041,816169,683122,578001,352417,618472,462183,214632,772160,742642,690557,642976,1035373,500391,795862,969543,471619,43194,576298,807350,863936,856763,182723,719628,291543,639623,484075,627674,803888,756414,826100,566490,78151,502364,37208,921274,611195,406054,237513,507913,927223,265204,827086,35895,462065,896942,636637,399957,924832,842659,600988,187364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]