SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687628 LIMIT 1 [ RunTime:0.000642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687628 [ RunTime:0.003078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542637,698736,78630,108243,953117,664920,1025587,112611,543582,190508,321499,366724,765233,451097,76051,624553,274067,661997,210331,706634,235074,638870,257793,256047,973458,727123,1019015,756323,703396,1029714,602274,638061,493615,480751,617756,666579,487585,112765,816541,656589,473653,836826,329613,922701,254342,153344,875384,881389,327366,106945,843987,1019181,392892,750028,436037,1005375,545260,634573,308863,4429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000864s ]